import pandas as pd
data = {'姓名': ['赵文', '李蒙', '刘武', '何花'],
        '职务': ['主管', '副主管', '员工', '员工'],
        '基本工资': [8000, 7000, 5000, 5500],
        '联系方式': ['152xxxx9852', '150xxxx5820', '136xxxx8962', '131xxxx9860']}
df = pd.DataFrame(data)
lihua = {'姓名': '李华', '职务': '员工', '基本工资': 5200, '联系方式': '136xxxx235'}
df = pd.concat([df, pd.DataFrame([lihua])], ignore_index=True)
df.insert(1, '性别',['女','男','男','女','女'])
df.loc[df['姓名']=='刘武','职务'] = '副主管'
# 输出所有员工信息
print("所有员工信息:\n", df)
print("单独输出主管的信息:\n", df[df['职务'] ==  '主管'])
print("单独输出副主管的信息:\n", df[df['职务'] ==  '副主管'])

df.to_csv('Score.csv',encoding='GBK')
df=pd.read_csv('Score.csv',index_col=0,encoding='GBK')
print('导入的数据:\n',df)